drop table jms_dwd.dwd_tab_ops_intervene_input_dt;
 create external table jms_dwd.dwd_tab_ops_intervene_input_dt
 (
   id                  bigint ,
   business_type       string,
   waybill_no          string,
   input_userid        string,
   input_usercode      string,
   input_username      string,
   input_network_id    string,
   input_network_code  string,
   input_network_name  string,
   input_content       string,
   input_time          string,
   is_delete           string,
   delete_time         string,
   status_code         string,
   reinput_time        string,
   updated_time        string,
   customer_label_name string
 )
COMMENT '干预平台数据表'
PARTITIONED BY (
  `dt` string COMMENT '入库时间(yyyy-MM-dd)')
STORED AS parquet
LOCATION
  '/dw/hive/jms_dwd.db/external/dwd_tab_ops_intervene_input_dt'